CREATE proc [dbo].[SP_INS_EMPLOYEES_values]    
 @EMP_ID int OUTPUT ,    
 @ACC_ID int ,  @EMP_FIRSTNAME nvarchar(100) ,   
 @EMP_LASTNAME nvarchar(100) ,    
@EMP_ADDRESS nvarchar(300) ,    
@EMP_PHONE nvarchar(12) ,  @EMP_STARTDATE dateTime ,  
 @EMP_LICENSE nvarchar(100) ,  @EMP_POSITION nvarchar(100),
@EMP_COMMISSION int     
as    
begin    
insert into [EMPLOYEES] ( [ACC_ID] ,  [EMP_FIRSTNAME] ,  [EMP_LASTNAME] ,  [EMP_ADDRESS] ,  [EMP_PHONE] ,  
[EMP_STARTDATE] ,  [EMP_LICENSE] ,  [EMP_POSITION],  [EMP_COMMISSION])    
values  ( @ACC_ID ,  @EMP_FIRSTNAME ,  @EMP_LASTNAME ,  @EMP_ADDRESS ,  @EMP_PHONE ,  @EMP_STARTDATE ,  @EMP_LICENSE ,  @EMP_POSITION, @EMP_COMMISSION )    
set @EMP_ID= SCOPE_IDENTITY()     
end 